<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@page import="com.jdbc.Jdbc"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="com.project.bean.*"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<% 
String sid = request.getParameter("sid");
String find = "select *from contract where id = '"+sid+"'";
   
  Jdbc j=new Jdbc();
  ResultSet rs;
  List<Contract> list=new ArrayList<>();
  j.Jdbc_Q2(find);
  rs=j.rs;
  while(rs.next()){
	  Contract c=new Contract();
	  c.setContractid(rs.getString("contractid"));
	  c.setId(rs.getString("id"));
	  c.setChinesename(rs.getString("chinesename"));
	  c.setEnglishname(rs.getString("englishname"));
	  c.setSex(rs.getString("sex"));
	  c.setBirthday(rs.getString("birthday"));
	  c.setCoursename(rs.getString("coursename"));
	  c.setTotalclass(rs.getString("totalclass"));
	  c.setRestclass(rs.getString("restclass"));
	  c.setTuition(rs.getString("tuition"));
	  c.setChargestate(rs.getString("chargestate"));
	  c.setSigntype(rs.getString("signtype"));
	  c.setCounselor(rs.getString("counselor"));	  
	  c.setPhonecounselor(rs.getString("phonecounselor"));
	  c.setChineseteacher(rs.getString("chineseteacher"));
	  c.setEnglishteacher(rs.getString("englishteacher"));
	  c.setUsername(rs.getString("username"));


	  
	  list.add(c);
  }%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<meta charset="utf-8">
<title>用户管理</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
	content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="format-detection" content="telephone=no">
<link rel="stylesheet" href="./css/x-admin.css" media="all">
</head>
<body>
	<div class="x-nav">
		<span class="layui-breadcrumb"> <a><cite>首页</cite></a> <a><cite>学生编号:<%=sid %></cite></a>
		</span> <a class="layui-btn layui-btn-small"
			style="line-height: 1.6em; margin-top: 3px; float: right"
			href="javascript:location.replace(location.href);" title="刷新"><i
			class="layui-icon" style="line-height: 30px">ဂ</i></a>
	</div>
	<div class="x-body">
		<form class="layui-form x-center" action="" style="width: 500px">
			<div class="layui-form-pane" style="margin-top: 15px;">
				<div class="layui-form-item">
					<div class="layui-input-inline" style="width: 400px"></div>
					<div class="layui-input-inline" style="width: 80px"></div>
				</div>
			</div>
		</form>
		<!-- <xblock>
		<button class="layui-btn"
			onclick="user_management_add('添加数据','contract_add.jsp','600','500')">
			<i class="layui-icon">&#xe608;</i>添加
		</button>
		<button class="layui-btn" onclick="">
			<form action="contractOutput" method="post">
				<input type="submit" class="layui-btn" value="签约信息导出">
			</form>
		</button>
		<button class="layui-btn"
			onclick="user_management_add('数据导入','contractInputDB.jsp','600','500')">
			<i class="layui-icon"></i>Excel导入数据库
		</button>
		<button class="layui-btn" onclick="">
			<form action="contractModel" method="post">
				<input type="submit" class="layui-btn" value="模板下载">
			</form>
		</button>

		<span class="x-right" style="line-height: 25px"></span></xblock> -->
		<table class="layui-table">
			<thead>
				<tr>
					
					<th>缴费状况</th>
					<th>签约形式</th>
					<th>顾问</th>
					<th>电话顾问</th>
					<th>中国老师</th>
					<th>外教</th>
					<th>录入用户</th>
					

				</tr>
			</thead>
			<tbody>
				<%
    for(Contract c:list){
   %>
				<tr>

					
					<td><%=c.getChargestate() %></td>
					<td><%=c.getSigntype() %></td>
					<td><%=c.getCounselor() %></td>
					<td><%=c.getPhonecounselor() %></td>
					<td><%=c.getChineseteacher() %></td>
					<td><%=c.getEnglishteacher() %></td>
					<td><%=c.getUsername() %></td>

					
				</tr>


			</tbody>
			<%} %>
		</table>

		<!-- <div id="page"></div> -->
	</div>
	<br />
	<br />
	<br />
	<script src="./lib/layui/layui.js" charset="utf-8"></script>
	<script src="./js/x-layui.js" charset="utf-8"></script>
	<script>
            layui.use(['laydate','element','laypage','layer'], function(){
                $ = layui.jquery;//jquery
              laydate = layui.laydate;//日期插件
              lement = layui.element();//面包导航
              laypage = layui.laypage;//分页
              layer = layui.layer;//弹出层

              //以上模块根据需要引入

              laypage({
                cont: 'page'
                ,pages: 100
                ,first: 1
                ,last: 100
                ,prev: '<em><</em>'
                ,next: '<em>></em>'
              }); 
              
              var start = {
                min: laydate.now()
                ,max: '2099-06-16 23:59:59'
                ,istoday: false
                ,choose: function(datas){
                  end.min = datas; //开始日选好后，重置结束日的最小日期
                  end.start = datas //将结束日的初始值设定为开始日
                }
              };
              
              var end = {
                min: laydate.now()
                ,max: '2099-06-16 23:59:59'
                ,istoday: false
                ,choose: function(datas){
                  start.max = datas; //结束日选好后，重置开始日的最大日期
                }
              };
              
            });

            //批量删除提交
             function delAll () {
                layer.confirm('确认要删除吗？',function(index){
                    //捉到所有被选中的，发异步进行删除
                    layer.msg('删除成功', {icon: 1});
                });
             }
             /*用户-添加*/
            function user_management_add(title,url,w,h){
                x_admin_show(title,url,w,h);
            }
            /*用户-查看*/
            function user_management_show(title,url,id,w,h){
                x_admin_show(title,url,w,h);
            }

             /*用户-停用*/
            function member_stop(obj,id){
                layer.confirm('确认要停用吗？',function(index){
                    //发异步把用户状态进行更改
                    $(obj).parents("tr").find(".td-manage").prepend('<a style="text-decoration:none" onClick="member_start(this,id)" href="javascript:;" title="启用"><i class="layui-icon">&#xe62f;</i></a>');
                    $(obj).parents("tr").find(".td-status").html('<span class="layui-btn layui-btn-disabled layui-btn-mini">已停用</span>');
                    $(obj).remove();
                    layer.msg('已停用!',{icon: 5,time:1000});
                });
            }

            /*用户-启用*/
            function member_start(obj,id){
                layer.confirm('确认要启用吗？',function(index){
                    //发异步把用户状态进行更改
                    $(obj).parents("tr").find(".td-manage").prepend('<a style="text-decoration:none" onClick="member_stop(this,id)" href="javascript:;" title="停用"><i class="layui-icon">&#xe601;</i></a>');
                    $(obj).parents("tr").find(".td-status").html('<span class="layui-btn layui-btn-normal layui-btn-mini">已启用</span>');
                    $(obj).remove();
                    layer.msg('已启用!',{icon: 6,time:1000});
                });
            }
            // 用户-编辑
            function user_management_edit (title,url,id,w,h) {
                x_admin_show(title,url,w,h); 
            }
            /*密码-修改*/
            function user_management_password(title,url,id,w,h){
                x_admin_show(title,url,w,h);  
            }
            //删除用户
            function user_management_delete(title,url,id,w,h){
                x_admin_show(title,url,w,h);  
            }
            /*用户-删除*/
            function member_del(obj,id){
                layer.confirm('确认要删除吗？',function(index){
                    //发异步删除数据
                    $(obj).parents("tr").remove();
                    layer.msg('已删除!',{icon:1,time:1000});
                });
            }
            </script>
	<script>
        var _hmt = _hmt || [];
        (function() {
          var hm = document.createElement("script");
          var s = document.getElementsByTagName("script")[0]; 
          s.parentNode.insertBefore(hm, s);
        })();
        </script>
</body>
</html>
